package com.jfl.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.jfl.base.BaseMapper;
import com.jfl.model.SysUser;

/**
 * 系统用户Mybatis Mapper
 * 
 * @author 赵炎
 * @version [V1.00, 2018年11月29日]
 * @since V1.00
 */
public interface SysUserMapper extends BaseMapper<SysUser>
{
    List<SysUser> selectUserList();

    @Select("select * from tbl_sys_user where user_name = #{userName}")
    SysUser selectByUserName(String userName);
    
    @Select("select * from tbl_sys_user where email = #{email}")
    SysUser selectByEmail(String email);

    @Select("select * from tbl_sys_user where phone = #{phone}")
    SysUser selectByPhone(String phone);
}
